IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_ApprovalTrace')
BEGIN
	DROP TABLE Rental_AppForm_ApprovalTrace
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_Attach')
BEGIN
	DROP TABLE Rental_AppForm_Attach
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_Deposit_PaySchedule')
BEGIN
	DROP TABLE Rental_AppForm_Deposit_PaySchedule
END
GO

IF EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_Option')
BEGIN
	DROP TABLE Rental_AppForm_Option
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_Turnover')
BEGIN
	DROP TABLE Rental_AppForm_Turnover
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Rental_AppForm_FreePeriod')
BEGIN
	DROP TABLE Rental_AppForm_FreePeriod
END
go


IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME=N'Rental_AppForm_D')
BEGIN
	DROP TABLE Rental_AppForm_D
END
GO

IF  EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = 'Rental_AppForm_M')
BEGIN
DROP TABLE Rental_AppForm_M
END
go



IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Unit_M')
BEGIN
	DROP TABLE Unit_M
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Agency_M')
BEGIN
	DROP TABLE Agency_M
END
go

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Landlord_Prov_Options')
BEGIN
	DROP TABLE Landlord_Prov_Options
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Landlord_Prov_M')
BEGIN
	DROP TABLE Landlord_Prov_M
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Handover_Con_M')
BEGIN
	DROP TABLE Handover_Con_M
END
GO


IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Add_Guarantee_M')
BEGIN
	DROP TABLE Add_Guarantee_M
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'Features_M')
BEGIN
	DROP TABLE Features_M
END
GO

IF  EXISTS (SELECT 0 FROM INFORMATION_SCHEMA.tables A WHERE A.TABLE_NAME = N'BusNature_M')
BEGIN
	DROP TABLE BusNature_M
END
GO

